Pandas Profiling Report

Dataset statistics

Number of variables	16
Number of observations	20000
Missing cells	8261
Missing cells (%)	2.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.4 MiB
Average record size in memory	128.0 B

Variable types

NUM	10
CAT	6

Warnings

`name` has a high cardinality: 19768 distinct values	High cardinality
`host_name` has a high cardinality: 6517 distinct values	High cardinality
`neighbourhood` has a high cardinality: 217 distinct values	High cardinality
`last_review` has a high cardinality: 1507 distinct values	High cardinality
`last_review` has 4123 (20.6%) missing values	Missing
`reviews_per_month` has 4123 (20.6%) missing values	Missing
`minimum_nights` is highly skewed (γ1 = 25.17996962)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`number_of_reviews` has 4123 (20.6%) zeros	Zeros
`availability_365` has 7176 (35.9%) zeros	Zeros

Reproduction

Analysis started	2021-10-02 05:39:28.425646
Analysis finished	2021-10-02 05:40:26.994624
Duration	58.57 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

id
Real number (ℝ_≥0)

UNIQUE

Distinct	20000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	18923800.78
Minimum	2539
Maximum	36485609
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	2539
5-th percentile	1193873.85
Q1	9393540.5
median	19521168.5
Q3	29129358.75
95-th percentile	35275607.45
Maximum	36485609
Range	36483070
Interquartile range (IQR)	19735818.25

Descriptive statistics

Standard deviation	11012232.42
Coefficient of variation (CV)	0.5819249812
Kurtosis	-1.233322955
Mean	18923800.78
Median Absolute Deviation (MAD)	9896304
Skewness	-0.07538052651
Sum	3.784760157e+11
Variance	1.212692628e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32493112	1	< 0.1%
2728293	1	< 0.1%
30741302	1	< 0.1%
5354796	1	< 0.1%
36308266	1	< 0.1%
31194309	1	< 0.1%
15509545	1	< 0.1%
13073701	1	< 0.1%
20775370	1	< 0.1%
169152	1	< 0.1%
Other values (19990)	19990	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2539	1	< 0.1%
3831	1	< 0.1%
5022	1	< 0.1%
5121	1	< 0.1%
5203	1	< 0.1%

Value	Count	Frequency (%)
36485609	1	< 0.1%
36485057	1	< 0.1%
36480292	1	< 0.1%
36479723	1	< 0.1%
36478343	1	< 0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	19768
Distinct (%)	98.9%
Missing	7
Missing (%)	< 0.1%
Memory size	156.2 KiB

Hillside Hotel	7
Brooklyn Apartment	7
Private Room	6
New york Multi-unit building	6
Home away from home	6
Other values (19763)	19961

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Hillside Hotel	7	< 0.1%
Brooklyn Apartment	7	< 0.1%
Private Room	6	< 0.1%
New york Multi-unit building	6	< 0.1%
Home away from home	6	< 0.1%
Private room in Manhattan	5	< 0.1%
Cozy Room	5	< 0.1%
Cozy Private Room	4	< 0.1%
Private room in Williamsburg	4	< 0.1%
Private room in Brooklyn	3	< 0.1%
Other values (19758)	19940	99.7%
(Missing)	7	< 0.1%

Frequencies of value counts

Unique

Unique	19599 ?
Unique (%)	98.0%

Histogram of lengths of the category

Length

Max length	179
Median length	36
Mean length	36.8906
Min length	1

host_id
Real number (ℝ_≥0)

Distinct	17027
Distinct (%)	85.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	67460344.07
Minimum	2571
Maximum	274273284
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	2571
5-th percentile	779450
Q1	7853718.25
median	31114309.5
Q3	106842560
95-th percentile	242095840.9
Maximum	274273284
Range	274270713
Interquartile range (IQR)	98988841.75

Descriptive statistics

Standard deviation	78579364.8
Coefficient of variation (CV)	1.164823066
Kurtosis	0.2087986308
Mean	67460344.07
Median Absolute Deviation (MAD)	27863859.5
Skewness	1.219649017
Sum	1.349206881e+12
Variance	6.174716572e+15
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
219517861	131	0.7%
107434423	89	0.4%
30283594	53	0.3%
12243051	37	0.2%
16098958	36	0.2%
137358866	36	0.2%
61391963	34	0.2%
22541573	32	0.2%
200380610	27	0.1%
2856748	24	0.1%
Other values (17017)	19501	97.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2571	1	< 0.1%
2787	3	< 0.1%
3151	1	< 0.1%
3415	1	< 0.1%
3563	1	< 0.1%

Value	Count	Frequency (%)
274273284	1	< 0.1%
274195458	1	< 0.1%
274103383	1	< 0.1%
274079964	1	< 0.1%
273870123	1	< 0.1%

host_name
Categorical

HIGH CARDINALITY

Distinct	6517
Distinct (%)	32.6%
Missing	8
Missing (%)	< 0.1%
Memory size	156.2 KiB

David	170
Michael	167
John	133
Sonder (NYC)	131
Alex	105
Other values (6512)	19286

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
David	170	0.9%
Michael	167	0.8%
John	133	0.7%
Sonder (NYC)	131	0.7%
Alex	105	0.5%
Daniel	95	0.5%
Blueground	89	0.4%
Sarah	87	0.4%
Maria	87	0.4%
Chris	83	0.4%
Other values (6507)	18845	94.2%

Frequencies of value counts

Unique

Unique	4203 ?
Unique (%)	21.0%

Histogram of lengths of the category

Length

Max length	35
Median length	6
Mean length	6.1112
Min length	1

neighbourhood_group
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Manhattan	8774
Brooklyn	8265
Queens	2355
Bronx	441
Staten Island	165

Frequencies
Length

Value	Count	Frequency (%)
Manhattan	8774	43.9%
Brooklyn	8265	41.3%
Queens	2355	11.8%
Bronx	441	2.2%
Staten Island	165	0.8%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	13
Median length	8
Mean length	8.1783
Min length	5

neighbourhood
Categorical

HIGH CARDINALITY

Distinct	217
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Williamsburg	1580
Bedford-Stuyvesant	1503
Harlem	1116
Bushwick	987
Upper West Side	798
Other values (212)	14016

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
Williamsburg	1580	7.9%
Bedford-Stuyvesant	1503	7.5%
Harlem	1116	5.6%
Bushwick	987	4.9%
Upper West Side	798	4.0%
Hell's Kitchen	771	3.9%
East Village	756	3.8%
Upper East Side	706	3.5%
Crown Heights	648	3.2%
Midtown	643	3.2%
Other values (207)	10492	52.5%

Frequencies of value counts

Unique

Unique	20 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	26
Median length	12
Mean length	11.8819
Min length	4

latitude
Real number (ℝ_≥0)

Distinct	12439
Distinct (%)	62.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	40.72845515
Minimum	40.50873
Maximum	40.91306
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	40.50873
5-th percentile	40.6451295
Q1	40.68942
median	40.72273
Q3	40.76299
95-th percentile	40.8256525
Maximum	40.91306
Range	0.40433
Interquartile range (IQR)	0.07357

Descriptive statistics

Standard deviation	0.05475507699
Coefficient of variation (CV)	0.001344393663
Kurtosis	0.1085655141
Mean	40.72845515
Median Absolute Deviation (MAD)	0.03658
Skewness	0.2301693808
Sum	814569.103
Variance	0.002998118457
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.68634	8	< 0.1%
40.72232	8	< 0.1%
40.71813	8	< 0.1%
40.69414	8	< 0.1%
40.72607	7	< 0.1%
40.68683	7	< 0.1%
40.70587	7	< 0.1%
40.71801	7	< 0.1%
40.68084	7	< 0.1%
40.71992	6	< 0.1%
Other values (12429)	19927	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
40.50873	1	< 0.1%
40.52293	1	< 0.1%
40.53076	1	< 0.1%
40.53871	1	< 0.1%
40.53884	1	< 0.1%

Value	Count	Frequency (%)
40.91306	1	< 0.1%
40.90527	1	< 0.1%
40.90391	1	< 0.1%
40.90356	1	< 0.1%
40.90329	1	< 0.1%

longitude
Real number (ℝ)

Distinct	10181
Distinct (%)	50.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-73.95212502
Minimum	-74.23914
Maximum	-73.71795
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	-74.23914
5-th percentile	-74.0041805
Q1	-73.98303
median	-73.95564
Q3	-73.93638
95-th percentile	-73.864896
Maximum	-73.71795
Range	0.52119
Interquartile range (IQR)	0.04665

Descriptive statistics

Standard deviation	0.04655878323
Coefficient of variation (CV)	-0.000629580059
Kurtosis	4.938242884
Mean	-73.95212502
Median Absolute Deviation (MAD)	0.024895
Skewness	1.255100378
Sum	-1479042.5
Variance	0.002167720296
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.98589	10	0.1%
-73.94829	9	< 0.1%
-73.95742	9	< 0.1%
-73.95427	9	< 0.1%
-73.95121	9	< 0.1%
-73.98043	9	< 0.1%
-73.95725	9	< 0.1%
-73.95332	8	< 0.1%
-73.95675	8	< 0.1%
-73.95509	8	< 0.1%
Other values (10171)	19912	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.23914	1	< 0.1%
-74.21238	1	< 0.1%
-74.20295	1	< 0.1%
-74.19826	1	< 0.1%
-74.19626	1	< 0.1%

Value	Count	Frequency (%)
-73.71795	1	< 0.1%
-73.71829	1	< 0.1%
-73.72582	1	< 0.1%
-73.72716	1	< 0.1%
-73.72731	1	< 0.1%

room_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Entire home/apt	10384
Private room	9172
Shared room	444

Frequencies
Length

Value	Count	Frequency (%)
Entire home/apt	10384	51.9%
Private room	9172	45.9%
Shared room	444	2.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	15
Median length	15
Mean length	13.5354
Min length	11

price
Real number (ℝ_≥0)

Distinct	544
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	153.26905
Minimum	0
Maximum	10000
Zeros	5
Zeros (%)	< 0.1%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	40
Q1	69
median	105
Q3	175
95-th percentile	350
Maximum	10000
Range	10000
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	243.3256089
Coefficient of variation (CV)	1.587571717
Kurtosis	538.297578
Mean	153.26905
Median Absolute Deviation (MAD)	45
Skewness	18.3046896
Sum	3065381
Variance	59207.35193
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	856	4.3%
150	821	4.1%
50	636	3.2%
200	590	2.9%
75	570	2.9%
60	555	2.8%
80	531	2.7%
70	482	2.4%
120	471	2.4%
65	471	2.4%
Other values (534)	14017	70.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	< 0.1%
10	6	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
10000	1	< 0.1%
9999	1	< 0.1%
8500	1	< 0.1%
7703	1	< 0.1%
7500	1	< 0.1%

minimum_nights
Real number (ℝ_≥0)

SKEWED

Distinct	75
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.9921
Minimum	1
Maximum	1250
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	30
Maximum	1250
Range	1249
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	21.64544903
Coefficient of variation (CV)	3.095700724
Kurtosis	1072.167601
Mean	6.9921
Median Absolute Deviation (MAD)	1
Skewness	25.17996962
Sum	139842
Variance	468.5254639
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
30	1540	7.7%
4	1328	6.6%
5	1208	6.0%
7	855	4.3%
6	307	1.5%
14	217	1.1%
10	183	0.9%
Other values (65)	1009	5.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5248	26.2%
2	4796	24.0%
3	3309	16.5%
4	1328	6.6%
5	1208	6.0%

Value	Count	Frequency (%)
1250	1	< 0.1%
999	2	< 0.1%
480	1	< 0.1%
400	1	< 0.1%
370	1	< 0.1%

number_of_reviews
Real number (ℝ_≥0)

ZEROS

Distinct	323
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	23.2741
Minimum	0
Maximum	607
Zeros	4123
Zeros (%)	20.6%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	5
Q3	23
95-th percentile	114
Maximum	607
Range	607
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	44.92779312
Coefficient of variation (CV)	1.930377248
Kurtosis	20.22980666
Mean	23.2741
Median Absolute Deviation (MAD)	5
Skewness	3.761375507
Sum	465482
Variance	2018.506595
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%
5	631	3.2%
6	560	2.8%
7	513	2.6%
8	469	2.3%
9	400	2.0%
Other values (313)	7919	39.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	4123	20.6%
1	2131	10.7%
2	1394	7.0%
3	1033	5.2%
4	827	4.1%

Value	Count	Frequency (%)
607	1	< 0.1%
594	1	< 0.1%
510	1	< 0.1%
488	1	< 0.1%
474	1	< 0.1%

last_review
Categorical

HIGH CARDINALITY
MISSING

Distinct	1507
Distinct (%)	9.5%
Missing	4123
Missing (%)	20.6%
Memory size	156.2 KiB

2019-06-23	575
2019-07-01	557
2019-06-30	553
2019-06-24	350
2019-07-07	292
Other values (1502)	13550

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-06-23	575	2.9%
2019-07-01	557	2.8%
2019-06-30	553	2.8%
2019-06-24	350	1.8%
2019-07-07	292	1.5%
2019-07-02	280	1.4%
2019-06-22	270	1.4%
2019-07-05	252	1.3%
2019-06-16	245	1.2%
2019-07-06	240	1.2%
Other values (1497)	12263	61.3%
(Missing)	4123	20.6%

Frequencies of value counts

Unique

Unique	358 ?
Unique (%)	2.3%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	8.55695
Min length	3

reviews_per_month
Real number (ℝ_≥0)

MISSING

Distinct	790
Distinct (%)	5.0%
Missing	4123
Missing (%)	20.6%
Infinite	0
Infinite (%)	0.0%

Mean	1.377445991
Minimum	0.01
Maximum	27.95
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.04
Q1	0.19
median	0.72
Q3	2.01
95-th percentile	4.67
Maximum	27.95
Range	27.94
Interquartile range (IQR)	1.82

Descriptive statistics

Standard deviation	1.683005621
Coefficient of variation (CV)	1.22183057
Kurtosis	11.95169963
Mean	1.377445991
Median Absolute Deviation (MAD)	0.62
Skewness	2.435799259
Sum	21869.71
Variance	2.83250792
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	378	1.9%
0.02	378	1.9%
0.05	352	1.8%
0.03	334	1.7%
0.04	274	1.4%
0.08	263	1.3%
0.16	255	1.3%
0.09	246	1.2%
0.06	234	1.2%
0.11	222	1.1%
Other values (780)	12941	64.7%
(Missing)	4123	20.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	18	0.1%
0.02	378	1.9%
0.03	334	1.7%
0.04	274	1.4%
0.05	352	1.8%

Value	Count	Frequency (%)
27.95	1	< 0.1%
20.94	1	< 0.1%
19.75	1	< 0.1%
17.82	1	< 0.1%
16.22	1	< 0.1%

calculated_host_listings_count
Real number (ℝ_≥0)

Distinct	47
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.95545
Minimum	1
Maximum	327
Zeros	0
Zeros (%)	0.0%
Memory size	156.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	14
Maximum	327
Range	326
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	32.43383053
Coefficient of variation (CV)	4.663081545
Kurtosis	70.36535249
Mean	6.95545
Median Absolute Deviation (MAD)	0
Skewness	8.096123898
Sum	139109
Variance	1051.953363
Monotocity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%
6	226	1.1%
8	168	0.8%
7	166	0.8%
327	131	0.7%
9	103	0.5%
Other values (37)	1123	5.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	13290	66.5%
2	2688	13.4%
3	1174	5.9%
4	570	2.9%
5	361	1.8%

Value	Count	Frequency (%)
327	131	0.7%
232	89	0.4%
121	53	0.3%
103	36	0.2%
96	73	0.4%

availability_365
Real number (ℝ_≥0)

ZEROS

Distinct	366
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	112.9012
Minimum	0
Maximum	365
Zeros	7176
Zeros (%)	35.9%
Memory size	156.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	44
Q3	229
95-th percentile	359
Maximum	365
Range	365
Interquartile range (IQR)	229

Descriptive statistics

Standard deviation	131.7622264
Coefficient of variation (CV)	1.167057803
Kurtosis	-1.007092224
Mean	112.9012
Median Absolute Deviation (MAD)	44
Skewness	0.75940929
Sum	2258024
Variance	17361.2843
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7176	35.9%
365	510	2.5%
364	225	1.1%
1	181	0.9%
5	136	0.7%
89	124	0.6%
179	121	0.6%
2	119	0.6%
3	118	0.6%
4	110	0.5%
Other values (356)	11180	55.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7176	35.9%
1	181	0.9%
2	119	0.6%
3	118	0.6%
4	110	0.5%

Value	Count	Frequency (%)
365	510	2.5%
364	225	1.1%
363	98	0.5%
362	69	0.3%
361	48	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
0	9138664	Private Lg Room 15 min to Manhattan	47594947	Iris	Queens	Sunnyside	40.74271	-73.92493	Private room	74	2	6	2019-05-26	0.13	1	5
1	31444015	TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC	8523790	Johlex	Manhattan	Hell's Kitchen	40.76682	-73.98878	Entire home/apt	170	3	0	NaN	NaN	1	188
2	8741020	Voted #1 Location Quintessential 1BR W Village Apt	45854238	John	Manhattan	West Village	40.73631	-74.00611	Entire home/apt	245	3	51	2018-09-19	1.12	1	0
3	34602077	Spacious 1 bedroom apartment 15min from Manhattan	261055465	Regan	Queens	Astoria	40.76424	-73.92351	Entire home/apt	125	3	1	2019-05-24	0.65	1	13
4	23203149	Big beautiful bedroom in huge Bushwick apartment	143460	Megan	Brooklyn	Bushwick	40.69839	-73.92044	Private room	65	2	8	2019-06-23	0.52	2	8
5	4402805	LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK	22807362	Jenny	Brooklyn	Prospect-Lefferts Gardens	40.66025	-73.96270	Entire home/apt	120	3	3	2018-08-28	0.05	1	16
6	30070126	✩Prime Renovated 1/1 Apartment in Upper East Side✩	4968673	Sean	Manhattan	Upper East Side	40.76831	-73.95929	Entire home/apt	200	5	2	2019-05-26	0.68	1	71
7	34231172	Fully renovated brick house floor in Brooklyn	59642348	Kevin	Brooklyn	Sunset Park	40.64550	-74.01262	Entire home/apt	95	1	9	2019-07-08	9.00	1	106
8	5856760	Renovated 1BR in exciting, convenient area	29408349	Chad	Manhattan	Chinatown	40.71490	-73.99976	Entire home/apt	179	5	7	2017-04-18	0.14	1	0
9	7929441	Beautiful Loft w/ Waterfront View!	1453898	Anthony	Brooklyn	Williamsburg	40.71268	-73.96676	Private room	105	2	232	2019-06-19	5.00	3	64

Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365
19990	5192459	Quiet Room in 4BR UWS Brownstone	10677483	Greg	Manhattan	Upper West Side	40.80173	-73.96625	Private room	70	1	0	NaN	NaN	1	0
19991	1327940	Huge Gorgeous Park View Apartment!	3290436	Hadar	Brooklyn	Flatbush	40.65335	-73.96257	Entire home/apt	120	3	13	2016-08-27	0.28	2	327
19992	23612681	Shared Room 1 Stop from Manhattan on the F Train	55724558	Taylor	Queens	Long Island City	40.76006	-73.94080	Private room	55	4	2	2019-06-01	0.65	5	89
19993	34485745	Midtown Manhattan Stunner - Private room	261632622	Royalton	Manhattan	Theater District	40.75491	-73.98507	Private room	100	1	3	2019-06-16	3.00	9	318
19994	25616250	Stylish, spacious, private 1BR apt in Ditmas Park	125396920	Adam	Brooklyn	Flatbush	40.64314	-73.95705	Entire home/apt	75	3	10	2019-01-03	0.84	1	0
19995	7094539	Tranquil haven in bubbly Brooklyn	2052211	Adriana	Brooklyn	Windsor Terrace	40.65360	-73.97546	Entire home/apt	143	14	2	2016-08-27	0.04	1	10
19996	4424261	Large 1 BR with backyard on UWS	3447311	Sarah	Manhattan	Upper West Side	40.80188	-73.96808	Entire home/apt	200	2	22	2019-05-21	0.50	1	0
19997	4545882	Amazing studio/Loft with a backyard	23569951	Kaveh	Manhattan	Upper East Side	40.78110	-73.94567	Entire home/apt	220	3	28	2019-05-23	0.50	1	293
19998	26518547	U2 comfortable double bed sleeps 2 guests	295128	Carol Gloria	Bronx	Clason Point	40.81225	-73.85502	Private room	80	1	4	2019-07-01	1.48	7	365
19999	33631782	Private Bedroom in Williamsburg Apt!	8569221	Andi	Brooklyn	Williamsburg	40.71829	-73.95819	Private room	109	3	3	2019-04-28	1.07	2	97

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows